speed up pg_upgrade with many large objects

Log in to edit
ID 5737
Title speed up pg_upgrade with many large objects
CI (CFBot) Summary
Stats (from CFBot) Patch version: v5, Patch count: 1, First patch: +103−6, All patches: +103−6
Tags Performance
Created 2025-05-05 19:24:43
Last modified 2025-07-18 16:06:06 (1 year ago)
Latest email 2025-07-21 14:38:57 (1 year ago)
Status
PG19-1 (2025-07-01 – 2025-07-31): Committed
Target version 19
Authors Nathan Bossart (bossartn)
Reviewers Hannu Krosing (hannukrosing), Saurabh Uttam (saurabhuttam), Nitin Motiani (nitinmotiani) Log in to become reviewer
Committer Nathan Bossart (bossartn)
Links
Emails
Horribly slow pg_upgrade performance with many Large Objects
First at 2025-04-07 20:33:47 by Hannu Krosing <hannuk at google.com>
Latest at 2025-07-21 14:38:57 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v5-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-07-14 17:51:20 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v5-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-07-14 17:51:20 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v4-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-07-14 16:24:14 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v3-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-07-10 21:42:23 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v2-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-05-07 14:51:19 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-05-05 19:23:25 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Mention-that-we-preserve-database-OIDs-in-pg_upgr.patch) at 2025-04-09 17:16:44 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
History
When Who What
2025-07-18 16:06:06 Nathan Bossart (bossartn) Closed in commitfest PG19-1 with status: Committed
2025-07-11 14:51:55 Nathan Bossart (bossartn) Added bossartn as committer
2025-07-11 14:51:54 Nathan Bossart (bossartn) New status: Ready for Committer
2025-05-14 16:25:12 Saurabh Uttam (saurabhuttam) Added saurabhuttam as reviewer
2025-05-14 16:19:35 Nitin Motiani (nitinmotiani) Added nitinmotiani as reviewer
2025-05-13 20:21:54 Hannu Krosing (hannukrosing) Added hannukrosing as reviewer
2025-05-05 19:24:43 Nathan Bossart (bossartn) Attached mail thread CAMT0RQSS-6qLH+zYsOeUbAYhop3wmQTkNmQpo5--QRDUR+qYmQ@mail.gmail.com
2025-05-05 19:24:43 Nathan Bossart (bossartn) Created patch record
Log in to edit